select * from dbo.InStoreBill
select * from dbo.InStoreBillDtl


update dbo.InStoreBill set BillID = 'C10-12-000' where BillID = 'R201012001'
update dbo.InStoreBillDtl set BillID = 'C10-12-000' where BillID = 'R201012001'

update dbo.InStoreBill set BillID = 'C10-12-001' where BillID = 'R201012002'
update dbo.InStoreBillDtl set BillID = 'C10-12-001' where BillID = 'R201012002'

update dbo.InStoreBill set BillID = 'C10-12-002' where BillID = 'R201012003'
update dbo.InStoreBillDtl set BillID = 'C10-12-002' where BillID = 'R201012003'

update dbo.InStoreBill set BillID = 'C10-12-003' where BillID = 'R201012004'
update dbo.InStoreBillDtl set BillID = 'C10-12-003' where BillID = 'R201012004'

update dbo.InStoreBill set BillID = 'C10-12-004' where BillID = 'R201012005'
update dbo.InStoreBillDtl set BillID = 'C10-12-004' where BillID = 'R201012005'

update dbo.InStoreBill set BillID = 'C10-12-005' where BillID = 'R201012006'
update dbo.InStoreBillDtl set BillID = 'C10-12-005' where BillID = 'R201012006'

update dbo.InStoreBill set BillID = 'C10-12-006' where BillID = 'R201012007'
update dbo.InStoreBillDtl set BillID = 'C10-12-006' where BillID = 'R201012007'

update dbo.InStoreBill set BillID = 'C10-12-007' where BillID = 'R201012008'
update dbo.InStoreBillDtl set BillID = 'C10-12-007' where BillID = 'R201012008'